package com.class04.mapper;

import com.class04.pojo.Employee;
import org.apache.ibatis.annotations.Select;

/**
 * @ClassDescription:规定数据方法可以
 * @JdkVersion: 17
 * @Author: yxy
 * @Created: 2023/11/13 8:08
 */
public interface EmployeeMapper {
    //    根据id查询员工信息
    @Select("select emp_id     empId,\n" +
            "               emp_name   empName,\n" +
            "               emp_salary empSalary\n" +
            "        from t_emp\n" +
            "        where emp_id = #{idjfjjf}")
    Employee queryById(Integer id);


    //    通过id删除员工
    int deleteById(Integer id);
}
